Error trace:
MSTError Object
(
[errorCode] =>
[message:protected] => ERROR.LOCAL: Code: 1722:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/sporttia_20Dic2017/libs/ModelBase.php
[line:protected] => 179
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/sporttia_20Dic2017/libs/ModelBase.php
[line] => 97
[function] => executeSQL
[class] => ModelBase
[type] => ->
[args] => Array
(
[0] =>
select
sc.*,
h2.ct_id, h2.ct_name, h2.ct_map_x, h2.ct_map_y, h2.c_name,
h2.pr_name, h2.pr_id, h2.pr_map_x, h2.pr_map_y,
(select count(*) from field where sportcenter_id=sc.id) as num_fields,
tc.bank as tc_bank,
h.integration_id
from sportcenter sc
left join (
select ins.sportcenter_id, ins.integration_id
from int_sportcenter ins, integration ig
where ins.integration_id = ig.id
) h on (sc.id = h.sportcenter_id)
left join customer cu on (sc.customer_id = cu.id)
left join tpv_conf tc on (sc.tpv_conf_id = tc.id)
left join (
select
c.id as ct_id, c.name as ct_name, c.map_x as ct_map_x, c.map_y as ct_map_y, c.name as c_name,
pr.name as pr_name, pr.id as pr_id, pr.map_x as pr_map_x, pr.map_y as pr_map_y
from city c, province pr
where c.province = pr.id
) h2 on (sc.city_id = h2.ct_id)
where 1=1
and sc.id = '{{sc.id}}' order by sc.id desc
[1] => 1
)
)
[1] => Array
(
[file] => /var/www/sporttia_20Dic2017/models/sportcenterModel.php
[line] => 173
[function] => executeSQL2
[class] => ModelBase
[type] => ->
[args] => Array
(
[0] =>
select
sc.*,
h2.ct_id, h2.ct_name, h2.ct_map_x, h2.ct_map_y, h2.c_name,
h2.pr_name, h2.pr_id, h2.pr_map_x, h2.pr_map_y,
(select count(*) from field where sportcenter_id=sc.id) as num_fields,
tc.bank as tc_bank,
h.integration_id
from sportcenter sc
left join (
select ins.sportcenter_id, ins.integration_id
from int_sportcenter ins, integration ig
where ins.integration_id = ig.id
) h on (sc.id = h.sportcenter_id)
left join customer cu on (sc.customer_id = cu.id)
left join tpv_conf tc on (sc.tpv_conf_id = tc.id)
left join (
select
c.id as ct_id, c.name as ct_name, c.map_x as ct_map_x, c.map_y as ct_map_y, c.name as c_name,
pr.name as pr_name, pr.id as pr_id, pr.map_x as pr_map_x, pr.map_y as pr_map_y
from city c, province pr
where c.province = pr.id
) h2 on (sc.city_id = h2.ct_id)
where 1=1
and sc.id = '{{sc.id}}' order by sc.id desc
)
)
[2] => Array
(
[file] => /var/www/sporttia_20Dic2017/controllers/timetableController.php
[line] => 30
[function] => find2
[class] => SportcenterModel
[type] => ->
[args] => Array
(
[0] => Array
(
[id] => {{sc.id}}
)
)
)
[3] => Array
(
[file] => /var/www/sporttia_20Dic2017/libs/FrontController.php
[line] => 41
[function] => index
[class] => TimetableController
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /var/www/sporttia_20Dic2017/index.php
[line] => 114
[function] => main
[class] => FrontController
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)